package com.bdqn.dao;

import bean.Lobby;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface LobbyDao {
    //进入大厅查询所有平台
    @Select("select * from t_platform")
    List<Lobby> findAll();
    //搜索框模糊查询
    @Select("SELECT * FROM t_platform WHERE name like concat('%',#{linkName},'%')")
    List<Lobby> findName(String name);
    //根据id查询当前的平台封装到实体类中
    @Select("select * from t_platform where id = #{id} ")
    Lobby findId(Integer id);

}
